Search results

I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "??????? I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???????" <?php $dbconn = new PDO('odbc:Driver=FreeTDS; Server=xxx.xxx.xxx.xx; Port=1433; Database=xxxxxx; UID=xxxx...

I need to Import table to access 2003 database from json file which i have received from public web service... I did before successfully from xml file.. is it possible from json file as well?

Well... I found one way... Using Visual Web Developer 2005 with ASP.net.. Well enough for start and usefully... Is there a way to do that with access 2003 ?

Is it possible to create simple web service with vb6/vba access 2003 to access sql database on server... In the biginig i need only to retrieve some data from sql database If it is..then please let some basic advice what to search around... If it is not some idea what free and simple software i...

So I do map drive on this way and it is successful ... Dim FSO As Object Dim objFile As Object Dim objFileS As Object Dim WshNet As Object persistent = false set objNetwork = CreateObject("WScript.Network") objNetwork.MapNetworkDrive "driveletter:", "\\server\sharename", persistent...

I want to set system time with vba code using win apis I use this code: Option Compare Database Option Explicit Private Declare Function SetSystemTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) As Long Private Type SYSTEMTIME wYear As Integer wMonth As Integer wDayOfWeek As...

I found this article http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c79bb2e1-8a74-4bd2-88a1-ce2ffa9f2a4d/get-connecting-client-pcs-name-or-ip-address?forum=transactsql as I could understand sys.dm_exec is not available in sql 2000

Just to explain exactly what i need... So I have WIN server 2003 as back end with sql server 2000 on it So I have several clients with access app connected to the server through VPN connection, and they need to know if some client is on line(connected to the server). I tried to ping them client...

Is there a way to get all currently connected addresses to SQL server 2000 from vba client app connected to the server

No I don't do that... just i noticed that connections info about links are stored over there so i consider if there is some way to refresh them somehow or to refresh system information just to reset previous connections are those articles could be usefully with this issue...

i told you... when connection has been lost... i should clear something... i don't know what...there must be a way to reconnect the tables after connection is reestablished

vbainet... i found something but i don't understand quite could you see this artikal http://support.microsoft.com/kb/195225

i tried your way... but no success ... conn string is ok and table table is ok so to resume my way as well work even is not written properly so i can refresh links in both ways problem is when i loose connection to server (i'm connected to the server throgh vpn) loosing connection can be caused...

In mean time i found something interesting, it might help that one I open systable MSysObjects so access write links inside, when i delete link manually or with code, the link in systable still exists, if i restart access if the link has been deleted before closing, it no exists anymore in...

:( No...That's what i already have... So I should look how to refresh msysobjects after i loose connection to sql server through vpn and then reconnect again

Function dao() tbl = "MyTable" CurrentDb.TableDefs.Delete tbl Set A = CurrentDb() Set B = A.CreateTableDef(tbl) B.Connect = "ODBC;driver={SQL Server};Server=MyServer;database=MyDataBase;uid=My User;pwd=MyPasword;" B.SourceTableName = tbl A.TableDefs.Append B A.TableDefs(tbl).RefreshLink End...

I send a short way of dao connection... in my code is written as you wrote... In mean time i found something interesting, it might help that one I open systable MSysObjects so access write links inside, when i delete link manually or with code, the link in systable still exists, if i restart...

i have done that i tried now one more time It doesn't work... Only way I can relink/refresh tables links is to change an ip adress in conn.string conn.string="ODBC;driver={SQL Server};Server=192.124.0.2(or .32); database=MyDataBase;uid=My User;pwd=MyPasword;" eg 192.124.0.2(1st ip- router...

Yes i tried, but doesn't help It seems that mdb/mde database keep first connection as active even it is broken... :(

I have MDB database linked to SQL SERVER through VPN connection... I created links to the sql server .. Links are dsnless... Everything works fine but when I lost VPN connection or sql connection has been broken I can't refresh links to the tables. I receive message 3146 sql connection failed...