I'm trying to create a remote ODBC connection to a Win Server 2003 that has an MSDE db on it but the db isn't installed as an instance, otherwise i think I could create ODBC using IP\instancename.
I have the IP to the server and can successfully remote in to the server but when setting up my ODBC to connect to the db on that server, I'm using the IP and entering the 'sa' account but it won't connect.
Can I use odbc to connect to an msde db if the db isnt installed as an instance? How?
I have the IP to the server and can successfully remote in to the server but when setting up my ODBC to connect to the db on that server, I'm using the IP and entering the 'sa' account but it won't connect.
Can I use odbc to connect to an msde db if the db isnt installed as an instance? How?