![]() ![]() ![]() So does that mean I just need to use some different syntax to specify the IP along with an instance name? What do I do? Thanks in advance. Based on the latter error I listed, it would seem that it can connect to the server, but simply cannot find the instance (since I didn't specify one that time). I know the SQL Server exists, works, and an ODBC connection can be set up properly I'm just not sure what it is I've got wrong in my connection settings that's throwing these errors. You might be thinking, "duh, you probably didn't open the firewall for port 1433, dummy." Except I did, and I verified this, as I can successfully run: telnet 123.456.789.012 1433 If I try the same thing, but change the "server" from 123.456.789.012\SQLEXPRESS to just plain old 123.456.789.012, I get a different error: Connection failed:ĬonnectionOpen (Invalid Instance()). SQL Server does not exist or access denied. When I put in the username and password and press Next, it stalls for a good 10 to 20 seconds, and then finally comes back with the following error: Connection failed:ĬonnectionOpen (Connect()). Setup ODBC top Install the latest Microsoft SQL Server ODBC drivers: Open the 64 bit ODBC Administrator: Open the System DSN tab and click Add: Choose the. But the ODBC connection doesn't seem to work there. Because it's on a different domain, it doesn't recognize the name "MYSERVER" I have to point it at the IP address of MYSERVER, which we'll say is 123.456.789.012. Source: Microsoft OLE DB Provider for ODBC Drivers. The delete happens, but it catches this error: Desc: Microsoft ODBC Driver 17 for SQL Server SQL ServerExecuting SQL directly no cursor. In 64-bit versions of windows, the default ODBC connection program that can be accessed from the start menu is the 64-bit version. But next, I've got another computer which is on a totally different domain/not on the intranet, that needs to access this same SQL Server hosted on MYSERVER. The problem: One example: Vbscript is calling a stored procedure with a simple delete from a Clasp page written in vbscript. ![]() ![]() I log in using SQL Server Authentication (not Windows authentication), and it's set up like this: Right on this server itself, I've got an ODBC connection set up pointing at itself, and that already works perfectly. I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Note: I've obviously changed the server names and IPs to fictitious ones. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |